Confirm Delete?
Are you sure you want to remove from the report?

Data Preview

Tail

  sales_person tgt_enc_sim_impt_functional_status model_family first_time_customer order_type days_since_last_purchase brand unit_cost tgt_enc_sim_impt_platforms quantity channel sku color tgt_enc_sim_impt_technology condition carrier memory_size business_unit lock_status unit_price
139842 119.852983 130.001970 137.066068 0.000000 133.414677 0.000000 138.128169 153.000000 141.795103 4.000000 132.120897 156.222221 148.029814 162.706079 231.236690 137.595979 84.349338 900.000000 135.232066 160.000000
139843 119.852983 130.001970 145.785332 0.000000 133.414677 0.000000 138.128169 97.006000 142.455969 1.000000 132.120897 137.783282 138.248964 128.068295 120.342959 137.595979 155.582144 900.000000 135.232066 130.000000
139844 149.058176 130.001970 142.682683 0.000000 133.414677 0.000000 138.128169 125.999000 163.237457 1.000000 132.120897 96.274460 138.248964 162.706079 100.957235 137.595979 110.841853 900.000000 135.232066 90.000000
139845 119.852983 130.001970 34.077742 0.000000 133.414677 0.000000 138.128169 25.000000 33.074447 1.000000 132.120897 31.300885 153.495556 82.853069 110.142066 137.595979 84.349338 900.000000 135.232066 35.000000
139846 119.852983 130.001970 113.284406 0.000000 133.414677 0.000000 138.128169 78.277000 89.452952 1.000000 90.690402 109.477298 148.029814 128.068295 120.342959 92.100800 179.528718 900.000000 135.232066 105.000000

Pre Processing

Pre Processing - Imputations

Pre Processing - Imputations - Missing

No missing values in data

Pre Processing - Imputations - Infinitys

No Infinity values

Health Analysis

Health Plot

Missing Plot

Missing Value Summary

No Missing Values

Duplicate Columns

No duplicate variables

Outliers In Features

Data Shape:(139847, 20)
feature < (mean-3*std) > (mean+3*std) < (1stQ - 1.5 * IQR) > (3rdQ + 1.5 * IQR) -inf +inf
sales_person 0 743 6 5702 0 0
tgt_enc_sim_impt_functional_status 0 10447 0 13543 0 0
model_family 0 2898 0 10368 0 0
first_time_customer 0 4281 0 4281 0 0
order_type 0 4040 0 4040 0 0
days_since_last_purchase 0 1743 0 2372 0 0
brand 5604 0 5604 0 0 0
unit_cost 0 3506 0 8502 0 0
tgt_enc_sim_impt_platforms 0 2742 0 9948 0 0
quantity 3 2357 169 15321 0 0
channel 0 2674 9216 6247 0 0
sku 0 2930 0 11243 0 0
color 442 2618 10700 4853 0 0
tgt_enc_sim_impt_technology 2266 0 2266 0 0 0
condition 0 1210 222 1210 0 0
carrier 5476 1963 9029 1963 0 0
memory_size 0 8094 0 8094 0 0
business_unit 7257 0 8515 8822 0 0
lock_status 158 0 158 4657 0 0
unit_price 0 2853 0 10408 0 0

Feature Analysis

Summary Stats

Summary Stats - Numeric Variables

  Variable Name Datatype No of Unique Samples Mean Standard Deviation Min 25th percentile Median 75th percentile Max
0 brand float64 2 [138.12816902184844, 89.490665064904] 136.179149 9.539257 89.490665 138.128169 138.128169 138.128169 138.128169
1 business_unit float64 10 [900.0, 904.0, 922.0, 480.32456422234065, 700.0] 876.751553 96.450346 480.324564 900.000000 900.000000 900.000000 935.000000
2 carrier float64 8 [137.59597888324086, 177.39227812657035, 93.08839858691479, 102.37927751834557, 97.88573248407643] 135.498681 11.327105 93.088399 137.595979 137.595979 137.595979 177.392278
3 channel float64 10 [132.12089741445845, 90.69040233666061, 146.6541923213651, 253.23132451965603, 81.386081300813] 132.367100 20.648167 68.406667 132.120897 132.120897 132.120897 253.231325
4 color float64 30 [138.2489639738742, 153.49555624450124, 58.65695707295374, 143.25272264133372, 103.57299342820437] 134.451534 33.019880 25.816035 120.758911 143.252723 148.029814 244.667803
5 condition float64 21 [110.1420661978082, 100.95723477538753, 120.34295941861212, 202.48760250482823, 195.4376402502607] 134.586005 42.791594 7.664739 110.142066 110.142066 165.638901 272.005940
6 days_since_last_purchase float64 3 [0.0, 1.8959041358031585, 1.0] 0.028128 0.220243 0.000000 0.000000 0.000000 0.000000 1.895904
7 first_time_customer float64 2 [0.0, 0.29965361163909293] 0.009173 0.051620 0.000000 0.000000 0.000000 0.000000 0.299654
8 lock_status float64 3 [135.23206602138754, 137.17599248443202, 129.99489380266414] 135.290883 0.391623 129.994894 135.232066 135.232066 135.232066 137.175992
9 memory_size float64 11 [110.84185308027186, 72.01804319654427, 84.34933772269558, 179.52871822004528, 155.5821439437734] 134.165864 64.151608 23.378892 84.349338 110.841853 155.582144 338.974196
10 model_family float64 183 [139.79359246088194, 69.55733681145352, 106.50990083905417, 86.0514243792325, 48.217917996870106] 132.820228 95.165548 8.369396 69.557337 98.612845 156.515299 451.812826
11 order_type float64 2 [133.41467696068688, 167.0326171114319] 134.385856 5.630815 133.414677 133.414677 133.414677 133.414677 167.032617
12 quantity float64 171 [100.0, 20.0, 1.0, 8.0, 2.0] 8.822181 20.775175 -107.054555 1.000000 2.000000 7.000000 129.699468
13 sales_person float64 13 [149.05817598516106, 119.85298332309411, 145.4403729333729, 216.8189755122439, 210.42307692307693] 134.679332 24.201388 70.436637 119.852983 119.852983 149.058176 221.810979
14 sku float64 5730 [141.9742571428571, 59.92203050847458, 106.47787610619469, 87.042071197411, 52.97278911564626] 132.002543 94.591170 5.322033 65.631579 106.265851 157.846154 446.975274
15 tgt_enc_sim_impt_functional_status float64 4 [130.0019700247023, 188.21983426727854, 139.89883877221325, 135.23926336639326] 134.570091 15.313211 130.001970 130.001970 130.001970 130.001970 188.219834
16 tgt_enc_sim_impt_platforms float64 166 [142.45596918511757, 78.99624829584185, 105.99506735751297, 81.79102022315203, 57.04693107344633] 132.572601 89.141895 7.369442 79.315704 96.965945 160.409558 437.301406
17 tgt_enc_sim_impt_technology float64 6 [128.0682946896036, 162.70607912677693, 82.85306886929344, 110.55211495629797, 171.44040834473324] 135.279436 26.600705 55.069065 128.068295 128.068295 162.706079 171.440408
18 unit_cost float64 39859 [160.49, 62.999, 68.086, 58.136, 37.691] 108.112298 83.779436 0.000000 49.865000 80.354000 139.534500 370.983182
19 unit_price float64 1800 [170.0, 55.0, 110.0, 88.0, 51.0] 135.239263 112.507163 0.000000 63.659000 100.000000 165.000000 1159.000000

Summary Stats - Non Numeric Variables

No categorical columns

Distributions

Distributions - Numeric Variables

Distributions - Numeric Variables - Brand

Distributions - Numeric Variables - Business Unit

Distributions - Numeric Variables - Carrier

Distributions - Numeric Variables - Channel

Distributions - Numeric Variables - Color

Distributions - Numeric Variables - Condition

Distributions - Numeric Variables - Days Since Last Purchase

Distributions - Numeric Variables - First Time Customer

Distributions - Numeric Variables - Lock Status

Distributions - Numeric Variables - Memory Size

Distributions - Numeric Variables - Model Family

Distributions - Numeric Variables - Order Type

Distributions - Numeric Variables - Quantity

Distributions - Numeric Variables - Sales Person

Distributions - Numeric Variables - Sku

Distributions - Numeric Variables - Tgt Enc Sim Impt Functional Status

Distributions - Numeric Variables - Tgt Enc Sim Impt Platforms

Distributions - Numeric Variables - Tgt Enc Sim Impt Technology

Distributions - Numeric Variables - Unit Cost

Distributions - Numeric Variables - Unit Price

Distributions - Non Numeric Variables

No categorical variables in data.

Feature Normality

Feature Interactions

Correlation Table

  Variable 1 Variable 2 Corr Coef Abs Corr Coef
0 sku unit_price 0.924854 0.924854
1 unit_price sku 0.924854 0.924854
2 model_family unit_price 0.919086 0.919086
3 unit_price model_family 0.919086 0.919086
4 unit_price tgt_enc_sim_impt_platforms 0.873985 0.873985
5 tgt_enc_sim_impt_platforms unit_price 0.873985 0.873985
6 unit_price unit_cost 0.867702 0.867702
7 unit_cost unit_price 0.867702 0.867702
8 unit_price memory_size 0.600660 0.600660
9 memory_size unit_price 0.600660 0.600660
10 unit_price condition 0.399041 0.399041
11 condition unit_price 0.399041 0.399041
12 channel unit_price 0.332982 0.332982
13 unit_price channel 0.332982 0.332982
14 unit_price color 0.318499 0.318499
15 color unit_price 0.318499 0.318499
16 tgt_enc_sim_impt_technology unit_price 0.237512 0.237512
17 unit_price tgt_enc_sim_impt_technology 0.237512 0.237512
18 sales_person unit_price 0.233028 0.233028
19 unit_price sales_person 0.233028 0.233028
20 tgt_enc_sim_impt_functional_status unit_price 0.156956 0.156956
21 unit_price tgt_enc_sim_impt_functional_status 0.156956 0.156956
22 brand unit_price 0.125676 0.125676
23 unit_price brand 0.125676 0.125676
24 quantity unit_price 0.124464 0.124464
25 unit_price quantity 0.124464 0.124464
26 unit_price carrier 0.122385 0.122385
27 carrier unit_price 0.122385 0.122385
28 unit_price business_unit -0.095195 0.095195
29 business_unit unit_price -0.095195 0.095195
30 unit_price order_type 0.094028 0.094028
31 order_type unit_price 0.094028 0.094028
32 unit_price first_time_customer 0.070741 0.070741
33 first_time_customer unit_price 0.070741 0.070741
34 unit_price days_since_last_purchase 0.061948 0.061948
35 days_since_last_purchase unit_price 0.061948 0.061948
36 unit_price lock_status 0.009686 0.009686
37 lock_status unit_price 0.009686 0.009686

Correlation Heatmap

Covariance Heatmap

Bivariate Plots (top 50 Correlations)

Bivariate Plots (top 50 Correlations) - Tgt Enc Sim Impt Platforms Vs Model Family

Bivariate Plots (top 50 Correlations) - Sku Vs Model Family

Bivariate Plots (top 50 Correlations) - Unit Price Vs Sku

Bivariate Plots (top 50 Correlations) - Unit Price Vs Model Family

Bivariate Plots (top 50 Correlations) - Tgt Enc Sim Impt Platforms Vs Sku

Bivariate Plots (top 50 Correlations) - Unit Price Vs Tgt Enc Sim Impt Platforms

Bivariate Plots (top 50 Correlations) - Unit Cost Vs Sku

Bivariate Plots (top 50 Correlations) - Unit Cost Vs Model Family

Bivariate Plots (top 50 Correlations) - Unit Price Vs Unit Cost

Bivariate Plots (top 50 Correlations) - Unit Cost Vs Tgt Enc Sim Impt Platforms

Bivariate Plots (top 50 Correlations) - Model Family Vs Memory Size

Bivariate Plots (top 50 Correlations) - Sku Vs Memory Size

Bivariate Plots (top 50 Correlations) - Unit Price Vs Memory Size

Bivariate Plots (top 50 Correlations) - Unit Cost Vs Memory Size

Bivariate Plots (top 50 Correlations) - Tgt Enc Sim Impt Platforms Vs Memory Size

Bivariate Plots (top 50 Correlations) - Tgt Enc Sim Impt Functional Status Vs Sales Person

Bivariate Plots (top 50 Correlations) - Carrier Vs Brand

Bivariate Plots (top 50 Correlations) - Sku Vs Condition

Bivariate Plots (top 50 Correlations) - Unit Price Vs Condition

Bivariate Plots (top 50 Correlations) - Model Family Vs Color

Bivariate Plots (top 50 Correlations) - Unit Cost Vs Channel

Bivariate Plots (top 50 Correlations) - Unit Cost Vs Condition

Bivariate Plots (top 50 Correlations) - Tgt Enc Sim Impt Functional Status Vs Condition

Bivariate Plots (top 50 Correlations) - Unit Cost Vs Color

Bivariate Plots (top 50 Correlations) - Sku Vs Color

Bivariate Plots (top 50 Correlations) - Unit Price Vs Channel

Bivariate Plots (top 50 Correlations) - Channel Vs Carrier

Bivariate Plots (top 50 Correlations) - Tgt Enc Sim Impt Platforms Vs Color

Bivariate Plots (top 50 Correlations) - Sales Person Vs Condition

Bivariate Plots (top 50 Correlations) - Unit Price Vs Color

Bivariate Plots (top 50 Correlations) - Tgt Enc Sim Impt Functional Status Vs Order Type

Bivariate Plots (top 50 Correlations) - Tgt Enc Sim Impt Technology Vs Tgt Enc Sim Impt Platforms

Bivariate Plots (top 50 Correlations) - Condition Vs Channel

Bivariate Plots (top 50 Correlations) - Unit Cost Vs Sales Person

Bivariate Plots (top 50 Correlations) - Unit Cost Vs Tgt Enc Sim Impt Technology

Bivariate Plots (top 50 Correlations) - Model Family Vs Channel

Bivariate Plots (top 50 Correlations) - Quantity Vs Channel

Bivariate Plots (top 50 Correlations) - Tgt Enc Sim Impt Technology Vs Model Family

Bivariate Plots (top 50 Correlations) - Tgt Enc Sim Impt Technology Vs Sku

Bivariate Plots (top 50 Correlations) - Sku Vs Channel

Bivariate Plots (top 50 Correlations) - Tgt Enc Sim Impt Platforms Vs Condition

Bivariate Plots (top 50 Correlations) - Tgt Enc Sim Impt Platforms Vs Channel

Bivariate Plots (top 50 Correlations) - Memory Size Vs Color

Bivariate Plots (top 50 Correlations) - Unit Price Vs Tgt Enc Sim Impt Technology

Bivariate Plots (top 50 Correlations) - Model Family Vs Condition

Bivariate Plots (top 50 Correlations) - Unit Price Vs Sales Person

Bivariate Plots (top 50 Correlations) - Channel Vs Brand

Bivariate Plots (top 50 Correlations) - Sku Vs Sales Person

Bivariate Plots (top 50 Correlations) - Color Vs Brand

Bivariate Plots (top 50 Correlations) - Tgt Enc Sim Impt Technology Vs Memory Size

Key Drivers

Unit Price

Unit Price - Feature Scores - Feature Correlation

Unit Price - Feature Importances - From Model

Unit Price - Pca Analysis

Unit Price - Pca Analysis - Pca Projection

Unit Price - Pca Analysis - Correlation With Dimension 2 (y)

Unit Price - Pca Analysis - Correlation With Dimension 1 (x)

Unit Price - Bivariate Plots

Unit Price - Bivariate Plots - Sales Person

Unit Price - Bivariate Plots - Tgt Enc Sim Impt Functional Status

Unit Price - Bivariate Plots - Model Family

Unit Price - Bivariate Plots - First Time Customer

Unit Price - Bivariate Plots - Order Type

Unit Price - Bivariate Plots - Days Since Last Purchase

Unit Price - Bivariate Plots - Brand

Unit Price - Bivariate Plots - Unit Cost

Unit Price - Bivariate Plots - Tgt Enc Sim Impt Platforms

Unit Price - Bivariate Plots - Quantity

Unit Price - Bivariate Plots - Channel

Unit Price - Bivariate Plots - Sku

Unit Price - Bivariate Plots - Color

Unit Price - Bivariate Plots - Tgt Enc Sim Impt Technology

Unit Price - Bivariate Plots - Condition

Unit Price - Bivariate Plots - Carrier

Unit Price - Bivariate Plots - Memory Size

Unit Price - Bivariate Plots - Business Unit

Unit Price - Bivariate Plots - Lock Status